Tabela BudgetPeriod

Definicja tabeli BudgetPeriod

Name

BudgetPeriod

Code

BudgetPeriod

Comment

Okresy budzetowe: rok, miesiac, kwartal, pólrocze


Lista kolumn tabeli BudgetPeriod

Name

Code

BudgetPeriodID

BudgetPeriodID

PeriodIndex

PeriodIndex

Active

Active


Kolumna BudgetPeriodID tabeli BudgetPeriod

Definicja kolumny BudgetPeriodID tabeli BudgetPeriod

Name

BudgetPeriodID

Code

BudgetPeriodID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID okresu


Kolumna PeriodIndex tabeli BudgetPeriod

Definicja kolumny PeriodIndex tabeli BudgetPeriod

Name

PeriodIndex

Code

PeriodIndex

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Kolejnosc w hierarchii


Kolumna Active tabeli BudgetPeriod

Definicja kolumny Active tabeli BudgetPeriod

Name

Active

Code

Active

Data Type

NUMBER(10)

Mandatory

No

Comment

Aktywny


Lista kluczy tabeli BudgetPeriod

Name

Code

Primary

PK_BUDGETPERIOD

PK_BUDGETPERIOD

X


Klucz PK_BUDGETPERIOD tabeli BudgetPeriod

Definicja klucza PK_BUDGETPERIOD tabeli BudgetPeriod

Name

PK_BUDGETPERIOD

Code

PK_BUDGETPERIOD

Primary

Yes

Comment